██    ██ ██    ██  ██████  ██  ██████  ██    ██ ███████ ██████  ██    ██ 
     ██  ██  ██    ██ ██       ██ ██    ██ ██    ██ ██      ██   ██  ██  ██  
      ████   ██    ██ ██   ███ ██ ██    ██ ██    ██ █████   ██████    ████   
       ██    ██    ██ ██    ██ ██ ██ ▄▄ ██ ██    ██ ██      ██   ██    ██    
       ██     ██████   ██████  ██  ██████   ██████  ███████ ██   ██    ██    
                                      ▀▀                                     
    

Sets - Execution started 16/01/2023 22:20 UTC
By Guilherme Ruiz

---

Table of Contents

• 1  Data aquisition
  • 1.1  Fetch set lists
  • 1.2  Fetch set properties
  • 1.3  Merge data
  • 1.4  Save data
• 3  Check changes
  • 3.1  Load previous data
  • 3.2  Generate changelog
• 4  Data visualization
  • 4.1  Full data
  • 4.2  Set
  • 4.3  Card number
  • 4.4  Name
  • 4.5  Rarity
    • 4.5.1  By unique
    • 4.5.2  By combination
  • 4.6  Print
  • 4.7  Quantity
  • 4.8  Region
  • 4.9  Cover card
  • 4.10  Series
  • 4.11  Set type
  • 4.12  Release
    • 4.12.1  By year
    • 4.12.2  By month
    • 4.12.3  By day
    • 4.12.4  By region
    • 4.12.5  By series
    • 4.12.6  By set type
• 5  Debug
  • 5.1  Has nan name/number
  • 5.2  Has nan rarity
  • 5.3  Has quantity as print
  • 5.4  Has nan release
  • 5.5  Has print as rarity
  • 5.6  Merge failed
• 6  Epilogue
  • 6.1  HTML export

Data aquisition

Fetch set lists

  0%|          | 0/80 [00:00<?, ?it/s]

4119 set lists received - 75 errors

Fetch set properties

  0%|          | 0/96 [00:00<?, ?it/s]

1433 set properties received - 3 errors

Merge data

Set properties merged

Save data

Data saved

Check changes

Load previous data

File loaded

Generate changelog

	Print	Version
Card number
CL03-SC004	<NA>	Old
CL03-SC004		New
CL03-SC005		New
CL03-SC005	<NA>	Old
CL03-SC006	<NA>	Old
...	...	...
CL03-SC188	<NA>	Old
CL03-SC189		New
CL03-SC189	<NA>	Old
CL03-SC190	<NA>	Old
CL03-SC190		New

322 rows × 2 columns

Changelog saved

Data visualization

Full data

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Modification date	_merge
0	2-Player Starter Deck: Yuya & Declan	YS15-PTY00	Odd-Eyes Saber Dragon	(Ultra Rare,)	<NA>	<NA>	PT	2015-05-29	<NA>	Starter Deck	(D/D/D Dragon King Pendragon, Odd-Eyes Saber D...	2020-11-08 22:53:12	both
1	2-Player Starter Deck: Yuya & Declan	YS15-PTY01	Alexandrite Dragon	(Common,)	<NA>	<NA>	PT	2015-05-29	<NA>	Starter Deck	(D/D/D Dragon King Pendragon, Odd-Eyes Saber D...	2020-11-08 22:53:12	both
2	2-Player Starter Deck: Yuya & Declan	YS15-PTY02	Mystical Elf	(Common,)	<NA>	<NA>	PT	2015-05-29	<NA>	Starter Deck	(D/D/D Dragon King Pendragon, Odd-Eyes Saber D...	2020-11-08 22:53:12	both
3	2-Player Starter Deck: Yuya & Declan	YS15-PTY03	Odd-Eyes Dragon	(Common,)	<NA>	<NA>	PT	2015-05-29	<NA>	Starter Deck	(D/D/D Dragon King Pendragon, Odd-Eyes Saber D...	2020-11-08 22:53:12	both
4	2-Player Starter Deck: Yuya & Declan	YS15-PTY04	Cyber Dragon	(Common,)	<NA>	<NA>	PT	2015-05-29	<NA>	Starter Deck	(D/D/D Dragon King Pendragon, Odd-Eyes Saber D...	2020-11-08 22:53:12	both
...	...	...	...	...	...	...	...	...	...	...	...	...	...
155887	Jump Festa 2010 - Promotion Pack	JF10-JP008	Sweet Corn	(Normal Parallel Rare,)	<NA>	<NA>	JP	2009-12-19	<NA>	Booster pack	NaN	2022-07-26 20:28:32	both
155888	Jump Festa 2010 - Promotion Pack	JF10-JP009	Vampiric Koala	(Normal Parallel Rare,)	<NA>	<NA>	JP	2009-12-19	<NA>	Booster pack	NaN	2022-07-26 20:28:32	both
155889	Jump Festa 2010 - Promotion Pack	JF10-JP010	Koalo-Koala	(Normal Parallel Rare,)	<NA>	<NA>	JP	2009-12-19	<NA>	Booster pack	NaN	2022-07-26 20:28:32	both
155890	Academia Disk	<NA>	<NA>	NaN	<NA>	<NA>	<NA>	NaT	<NA>	<NA>	NaN	2022-12-28 20:46:20	right_only
155891	Structure Deck: Marik (disambiguation)	<NA>	<NA>	NaN	<NA>	<NA>	<NA>	NaT	<NA>	<NA>	NaN	2014-07-03 18:52:14	right_only

155892 rows × 13 columns

Full data available here

Set

Total number of sets: 1438

	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Modification date	_merge
Set
"Amabie-San" Present Campaign	2	1	1	0	0	1	1	0	1	0	1	1
"Blue-Eyes White Dragon Rush Rare Special Red Version" GET Campaign	2	1	1	0	0	2	2	0	1	0	1	1
"Blue-Eyes White Dragon Secret Rare Special Blue Version" GET Campaign	1	1	1	0	0	1	1	0	1	0	1	1
"Blue-Eyes White Dragon" 20th Anniversary Gold Edition	0	1	0	0	0	1	1	0	1	0	1	1
"Blue-Eyes White Dragon" 20th Anniversary Silver Edition	0	1	0	0	0	1	1	0	1	0	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...
Yu-Gi-Oh! ZEXAL World Duel Carnival Duel Champion Guide! promotional card	1	1	1	0	0	1	1	0	1	0	1	1
Yu-Gi-Oh! ZEXAL World Duel Carnival promotional cards	18	3	1	0	0	6	2	0	1	0	1	1
Yugi's Legendary Decks	650	112	3	0	0	5	2	0	1	0	1	1
Zexal Collection Tin	120	24	3	0	0	5	1	0	1	1	1	1
Zombie World Structure Deck	185	37	2	0	2	5	1	0	1	1	1	1

1438 rows × 12 columns

	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Modification date	_merge
count	1438.000000	1438.000000	1438.000000	1438.000000	1438.000000	1438.000000	1438.000000	1438.000000	1438.000000	1438.000000	1438.000000	1438.0
mean	106.800417	27.494437	2.428373	0.349096	0.099444	2.690542	1.454798	0.390125	0.953408	0.310153	0.994437	1.0
std	235.788887	45.313180	2.327728	0.813403	0.455981	2.296603	0.996361	0.487948	0.210838	0.462717	0.074406	0.0
min	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	1.0
25%	1.000000	1.000000	1.000000	0.000000	0.000000	1.000000	1.000000	0.000000	1.000000	0.000000	1.000000	1.0
50%	10.000000	5.000000	1.000000	0.000000	0.000000	1.000000	1.000000	0.000000	1.000000	0.000000	1.000000	1.0
75%	86.000000	40.000000	3.000000	0.000000	0.000000	5.000000	2.000000	1.000000	1.000000	1.000000	1.000000	1.0
max	1652.000000	307.000000	17.000000	6.000000	3.000000	10.000000	9.000000	1.000000	1.000000	1.000000	1.000000	1.0

Card number

Total number of card numbers: 151713

	Set	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Modification date	_merge
Card number
15AX-JP000	2	1	1	1	0	1	1	0	1	0	2	1
15AX-JPM01	1	1	1	1	0	1	1	0	1	0	1	1
15AX-JPM02	1	1	1	1	0	1	1	0	1	0	1	1
15AX-JPM03	1	1	1	1	0	1	1	0	1	0	1	1
15AX-JPM04	1	1	1	1	0	1	1	0	1	0	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...
ZTIN-SP021	1	1	1	0	0	1	1	0	1	1	1	1
ZTIN-SPV01	1	1	1	0	0	1	1	0	1	1	1	1
ZTIN-SPV02	1	1	1	0	0	1	1	0	1	1	1	1
ZTIN-SPV03	1	1	1	0	0	1	1	0	1	1	1	1
<NA>	44	406	6	2	0	10	40	6	11	6	43	3

151714 rows × 12 columns

Name

Total number of card names: 12572

	Set	Card number	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Modification date	_merge
Name
"A Legendary Ocean"	1	1	0	0	0	1	1	0	1	1	1	1
"A" Cell Breeding Device	4	9	1	1	0	7	6	1	2	3	4	1
"A" Cell Incubator	2	8	1	2	0	7	6	1	1	2	2	1
"A" Cell Recombination Device	1	8	1	0	0	8	4	1	1	1	1	1
"A" Cell Scatter Burst	3	9	1	1	0	7	6	1	1	3	3	1
...	...	...	...	...	...	...	...	...	...	...	...	...
Zubaba Knight	12	50	5	1	1	8	23	2	2	7	12	1
Zubababancho Gagagacoat	1	2	1	1	0	2	2	1	1	1	1	1
Zure, Knight of Dark World	8	24	1	1	1	10	14	1	4	4	8	1
Zushin the Sleeping Giant	3	14	3	1	0	8	4	1	2	3	3	1
<NA>	10	194	3	1	0	9	13	5	4	5	10	2

12573 rows × 12 columns

	Set	Card number	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Modification date	_merge
count	12572.000000	12572.000000	12572.000000	12572.000000	12572.000000	12572.000000	12572.000000	12572.000000	12572.000000	12572.000000	12572.000000	12572.000000
mean	3.144846	12.053373	2.073258	0.670617	0.112393	6.880926	5.987273	1.089564	1.474069	1.844018	3.133551	1.010818
std	3.517214	11.600389	1.495081	0.672838	0.342446	2.567562	5.904821	0.787357	0.938340	1.842133	3.496589	0.103448
min	1.000000	0.000000	0.000000	0.000000	0.000000	1.000000	0.000000	0.000000	0.000000	0.000000	0.000000	1.000000
25%	1.000000	7.000000	1.000000	0.000000	0.000000	6.000000	3.000000	1.000000	1.000000	1.000000	1.000000	1.000000
50%	2.000000	9.000000	2.000000	1.000000	0.000000	8.000000	4.000000	1.000000	1.000000	1.000000	2.000000	1.000000
75%	4.000000	14.000000	3.000000	1.000000	0.000000	8.000000	7.000000	1.000000	2.000000	2.000000	4.000000	1.000000
max	80.000000	275.000000	28.000000	4.000000	3.000000	15.000000	122.000000	12.000000	16.000000	41.000000	80.000000	2.000000

Rarity

Total number of rarities: 54

By unique

	Set	Card number	Name	Print	Quantity	Region	Release	Series	Set type	Cover card	Modification date	_merge
Rarity
10000 Secret Rare	2	7	1	1	0	7	2	1	1	2	2	1
20th Secret Rare	16	135	134	3	0	1	13	3	3	6	16	1
@released::(from July 17)	1	1	1	0	0	1	0	0	0	0	1	1
@released::(from July 31)	1	1	1	0	0	1	0	0	0	0	1	1
@released::(from September 18)	1	2	1	0	0	1	0	0	0	0	1	1
Collector's Rare	6	226	76	2	0	7	6	2	1	6	6	1
Collectors Rare	8	112	112	2	0	1	8	1	1	7	8	1
Common	559	76881	8557	6	3	17	924	25	23	268	557	2
Duel Terminal Normal Parallel Rare	38	1906	511	2	0	7	34	1	3	11	38	1
Duel Terminal Normal Rare Parallel Rare	5	15	15	0	0	1	5	0	1	4	5	1
Duel Terminal Rare Parallel Rare	34	368	141	2	0	2	31	0	1	10	34	1
Duel Terminal Secret Parallel Rare	16	103	55	1	0	1	16	0	1	10	16	1
Duel Terminal Super Parallel Rare	34	240	85	2	0	2	31	0	1	10	34	1
Duel Terminal Ultra Parallel Rare	42	371	87	2	0	7	33	1	5	18	42	1
Extra Secret Parallel Rare	3	10	6	0	0	2	4	0	2	1	3	1
Extra Secret Rare	24	77	50	1	1	3	31	3	5	17	24	1
Ghost Rare	35	255	47	3	0	7	63	1	2	34	35	1
Ghost/Gold Rare	1	30	6	0	0	5	2	1	1	0	1	1
Gold Rare	23	2057	363	2	0	9	39	3	5	0	23	1
Gold Rush Rare	2	16	16	2	0	1	2	0	1	1	2	1
Gold Secret Rare	8	644	154	2	0	9	17	1	3	0	8	1
Holographic Parallel Rare	2	2	2	1	0	1	2	0	1	0	2	1
Holographic Rare	68	123	65	2	0	6	121	3	2	65	68	1
Kaiba Corporation Common	10	10	10	0	0	1	8	0	1	0	10	1
Kaiba Corporation Rare	5	5	5	0	0	1	5	1	2	0	5	1
Kaiba Corporation Ultra Rare	3	3	3	0	0	1	3	0	2	0	3	1
Millennium Gold Rare	2	9	6	2	0	2	2	0	1	2	2	1
Millennium Rare	8	316	152	3	0	3	9	2	6	2	8	1
Millennium Secret Rare	1	4	2	1	0	2	0	0	1	1	1	1
Millennium Super Rare	1	40	20	1	0	2	0	0	1	1	1	1
Millennium Ultra Rare	1	16	8	1	0	2	0	0	1	1	1	1
Mosaic Rare	1	1290	215	0	0	6	2	0	1	1	1	1
New	2	1	18	1	1	1	2	1	2	2	2	1
Normal Parallel Rare	134	2084	1006	4	1	4	166	7	10	61	134	1
Normal Rare	81	575	299	2	0	7	151	3	2	72	81	1
Orr	1	1	1	0	0	1	1	1	1	1	1	1
Platinum Secret Rare	2	24	4	0	0	6	4	0	1	2	2	1
Prismatic Secret Rare	40	1393	366	3	0	11	49	6	4	15	40	1
Rare	249	18507	3499	7	2	15	545	13	8	177	248	2
Reprint	6	0	35	0	0	1	6	3	1	1	6	1
Rush Rare	16	106	51	0	0	2	28	1	2	13	16	1
Secret Parallel Rare	2	12	6	1	0	2	4	0	1	0	2	1
Secret Rare	373	10357	2293	11	1	15	532	20	20	200	368	2
Shatterfoil Rare	4	1482	292	0	1	7	5	1	2	4	4	1
Short Print	56	1316	234	3	0	10	110	3	1	46	56	1
Starfoil Rare	6	2019	380	0	0	6	9	1	3	4	6	1
Starlight Rare	12	316	56	2	0	6	13	1	1	12	12	1
Super Parallel Rare	6	154	82	3	1	3	10	1	3	2	6	1
Super Rare	585	20188	3887	9	1	17	953	26	20	276	581	2
Super Short Print	1	35	5	1	0	7	0	1	1	1	1	1
Ultimate Rare	115	4315	847	2	1	11	278	5	6	85	114	2
Ultra Parallel Rare	67	279	170	3	1	7	63	4	7	20	66	2
Ultra Rare	784	17912	3171	7	2	17	1069	33	26	278	782	2
Ultra Secret Rare	1	0	6	0	0	1	1	1	1	0	1	1
NaN	37	397	367	3	0	6	31	6	9	5	36	3

By combination

	Set	Card number	Name	Print	Quantity	Region	Release	Series	Set type	Cover card	Modification date	_merge
Rarity
(10000 Secret Rare,)	2	7	1	1	0	7	2	1	1	2	2	1
(20th Secret Rare,)	9	25	24	1	0	1	8	2	3	1	9	1
(@released::(from July 17),)	1	1	1	0	0	1	0	0	0	0	1	1
(@released::(from July 31),)	1	1	1	0	0	1	0	0	0	0	1	1
(@released::(from September 18),)	1	2	1	0	0	1	0	0	0	0	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...
(Ultra Rare, Ultimate Rare, Ultra Parallel Rare)	1	1	1	0	0	1	1	1	1	1	1	1
(Ultra Rare, Ultra Parallel Rare)	22	71	67	0	0	1	16	3	2	16	21	2
(Ultra Rare, Ultra Parallel Rare, Ultimate Rare)	5	5	5	0	0	1	3	2	1	3	5	1
(Ultra Secret Rare,)	1	0	6	0	0	1	1	1	1	0	1	1
NaN	37	397	367	3	0	6	31	6	9	5	36	3

125 rows × 12 columns

Print

Total number of prints: 18

	Set	Card number	Name	Rarity	Quantity	Region	Release	Series	Set type	Cover card	Modification date	_merge
Print
	1	161	0	0	0	1	1	1	1	0	1	1
2	1	0	1	0	0	1	1	0	1	1	1	1
American debut	1	3	3	1	0	1	1	0	1	1	1	1
European & Oceanian debut	1	6	6	1	0	1	1	0	1	0	1	1
European debut	12	146	146	5	0	2	10	0	2	1	12	1
Functional errata	1	2	2	1	0	1	1	0	1	1	1	1
New	226	11563	3861	50	3	11	243	18	13	129	224	2
New art	1	4	2	1	0	2	2	0	1	1	1	1
New artwork	10	74	15	5	0	7	12	3	4	4	10	1
New artwork (renamed)	1	3	3	1	0	1	1	0	1	0	1	1
North American debut	2	4	4	2	0	2	2	0	2	0	2	1
Oceanian debut	1	1	1	1	0	1	1	0	1	0	1	1
Reprint	223	13915	4287	49	3	11	240	17	12	127	221	2
Reprint (New Art)	2	2	1	2	0	2	2	1	1	1	2	1
Reprint (functional errata)	15	33	21	10	0	8	14	3	3	5	15	1
Reprint (new artwork)	1	1	1	1	0	1	1	0	1	1	1	1
Reprint (renamed)	2	76	76	6	0	1	2	1	1	0	2	1
TCG legal debut	1	1	1	1	0	1	1	1	1	1	1	1
<NA>	1358	125895	11472	113	3	17	1451	41	37	315	1350	3

Quantity

Total number of quantities: 3

	Set	Card number	Name	Rarity	Print	Region	Release	Series	Set type	Cover card	Modification date	_merge
Quantity
1	67	8858	1215	11	2	11	108	1	6	46	66	2
2	66	855	173	4	2	11	108	1	6	45	65	2
3	10	74	25	1	2	8	12	0	4	8	10	1
<NA>	1373	141938	12463	123	18	17	1501	45	36	314	1365	3

Region

Total number of regions: 17

	Set	Card number	Name	Rarity	Print	Quantity	Release	Series	Set type	Cover card	Modification date	_merge
Region
AE	34	1527	1493	12	0	2	31	2	7	19	34	1
AU	2	100	87	3	0	0	1	0	1	2	2	1
DE	454	20312	10354	45	4	3	380	12	18	218	453	2
EN	657	20183	10480	51	14	3	535	22	23	207	656	2
ES	1	100	100	7	0	0	0	1	1	1	1	1
EU	25	543	456	8	3	0	16	2	9	6	25	1
FC	3	102	87	3	0	0	1	0	2	2	3	1
FR	448	19719	10341	46	4	3	375	14	18	218	447	2
IT	446	19991	10349	46	4	3	377	12	18	217	445	2
JA	3	185	185	8	0	0	3	2	2	3	3	1
JP	718	19113	11206	92	7	3	530	28	28	247	713	2
KR	383	15937	10754	55	4	3	333	16	15	224	378	2
NA	47	1526	1333	10	4	2	39	5	11	12	47	1
PT	203	12401	7783	40	4	3	164	8	10	119	203	1
SC	23	1237	1032	12	3	0	23	5	1	12	23	1
SP	415	19051	10181	45	4	3	354	9	17	203	414	2
TC	7	300	286	12	0	2	5	2	2	3	7	1
<NA>	2	0	0	0	0	0	0	0	0	0	2	1

	Set	Card number	Name	Rarity	Print	Quantity	Release	Series	Set type	Cover card	Modification date	_merge
count	18.000000	18.000000	18.000000	18.00000	18.000000	18.000000	18.000000	18.000000	18.000000	18.000000	18.000000	18.000000
mean	215.055556	8462.611111	4805.944444	27.50000	3.055556	1.666667	175.944444	7.777778	10.166667	95.166667	214.222222	1.388889
std	252.650298	9273.573790	5007.035174	25.53717	3.489012	1.414214	203.421750	8.156957	8.759868	105.505088	251.558800	0.501631
min	1.000000	0.000000	0.000000	0.00000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	1.000000	1.000000
25%	4.000000	213.750000	210.250000	8.00000	0.000000	0.000000	3.500000	2.000000	2.000000	3.000000	4.000000	1.000000
50%	40.500000	1526.500000	1413.000000	12.00000	3.500000	2.000000	35.000000	5.000000	9.500000	15.500000	40.500000	1.000000
75%	438.250000	19097.500000	10347.000000	45.75000	4.000000	3.000000	369.750000	12.000000	17.750000	214.500000	437.250000	2.000000
max	718.000000	20312.000000	11206.000000	92.00000	14.000000	3.000000	535.000000	28.000000	28.000000	247.000000	713.000000	2.000000

Cover card

Total number of cover cards: 671

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Modification date	_merge
Cover card
A-to-Z-Dragon Buster Cannon	1	352	54	4	2	2	8	4	0	1	1	1
Accel Synchro Stardust Dragon	1	100	50	3	2	0	2	2	0	1	1	1
Accesscode Talker	1	766	101	16	2	0	8	3	1	1	1	1
Adamancipator Risen - Dragite	1	135	45	3	2	0	3	3	0	1	1	1
Adreus, Keeper of Armageddon	1	84	42	4	0	0	2	2	0	1	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...
Yamiterasu the Divine Ruler	1	132	66	6	0	0	2	2	1	1	1	1
Yoko, the Graceful Mayakashi	2	450	60	4	2	0	8	3	0	1	2	1
Yubel - The Ultimate Nightmare	2	560	100	10	0	0	6	5	1	2	2	1
Z-Metal Tank	1	55	55	7	0	0	1	1	1	1	1	1
Zerrziel, Ruler of the Evil Eyed	1	90	45	3	2	0	2	2	0	1	1	1

671 rows × 12 columns

Series

Total number of series: 45

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Set type	Cover card	Modification date	_merge
Series
+1 Bonus Pack	7	249	137	3	0	0	2	12	1	0	7	1
Animation Chronicle	2	200	100	7	2	0	2	4	1	2	2	1
Astral Pack	7	1110	184	4	4	0	6	16	1	0	7	1
Attribute Duelist Pack	4	429	199	6	3	0	3	9	1	4	4	1
Battle Pack (Rush Duel)	8	80	80	3	3	0	1	8	1	0	8	1
Booster (series)	4	181	176	8	0	0	1	4	1	2	4	1
Booster pack	1	50	50	3	0	0	1	1	1	0	1	1
Champion Pack	8	640	161	4	2	0	4	8	1	0	8	1
Classic Pack	3	570	409	9	3	0	1	3	1	2	3	1
Collectors Pack	8	794	374	12	3	0	3	16	1	8	8	1
Core Booster	88	49929	7471	39	2	0	14	296	1	80	88	1
Deck Build Pack	3	360	134	5	2	0	3	8	1	3	3	1
Deck Mod Pack	12	1447	750	8	0	0	2	23	1	12	12	1
Duelist Pack	21	3739	634	7	3	0	8	49	1	19	21	1
Entry Pack (series)	10	163	160	3	2	0	1	10	1	0	10	1
Expansion Pack	4	280	280	6	0	0	1	4	1	0	4	1
Gold Series (series)	8	2595	446	9	2	0	9	18	1	0	8	1
Hidden Arsenal (series)	7	2470	400	2	2	0	7	16	1	7	7	1
Hobby League	1	83	43	3	0	0	5	0	1	0	1	1
Jump Victory Carnival	1	1	1	1	0	0	1	1	1	0	1	1
Legend Duelist (series)	6	780	343	9	2	0	3	14	1	6	6	1
Legendary Collection (series)	2	57	19	1	2	0	3	4	1	0	2	1
Master Guide promotional cards (series)	4	8	8	1	0	0	1	4	1	0	4	1
Mattel Action Figure promotional cards	3	17	16	1	0	0	1	3	1	0	3	1
McDonald's Promotional Cards	2	35	35	4	3	0	2	2	1	0	2	1
Monster Figure Collection promotional cards	3	15	15	1	0	0	1	3	1	0	3	1
OTS Tournament Pack	2	324	54	4	0	0	6	3	1	0	2	1
Perfect Rulebook promotional cards	3	3	3	2	0	0	1	3	1	0	3	1
Pharaoh Tour promotional cards	3	20	5	2	0	0	4	3	1	0	3	1
Premium Pack	25	452	368	9	3	0	2	25	1	12	25	1
Shonen Jump promotional cards	78	85	81	2	0	0	2	44	1	0	78	1
Sneak Peek Participation Cards	57	302	61	2	0	0	8	69	1	0	57	1
Star Pack	3	900	149	4	0	0	6	6	1	3	3	1
Structure Deck R	3	248	122	5	2	2	2	6	1	3	3	1
The Valuable Book promotional cards	18	38	38	2	0	0	2	19	1	0	18	1
V Jump August 1999 Special Present	1	0	6	1	0	0	1	1	1	0	1	1
V Jump Edition (series)	4	16	16	3	0	0	1	4	1	0	4	1
V Jump promotional cards	78	94	98	5	0	0	1	74	1	0	78	1
Value Box	9	11	11	3	0	0	1	7	1	0	9	1
Yu-Gi-Oh! 5D's manga promotional cards	9	19	9	1	0	0	3	18	1	0	9	1
Yu-Gi-Oh! Day promotional cards	7	7	1	1	0	0	2	7	1	0	7	1
Yu-Gi-Oh! GX manga promotional cards	9	19	9	2	0	0	3	17	1	0	9	1
Yu-Gi-Oh! R promotional cards	4	8	4	2	0	0	2	8	1	0	4	1
Yu-Gi-Oh! World Championship prize cards	13	35	30	5	0	0	3	13	1	0	13	1
Yu-Gi-Oh! ZEXAL manga promotional cards	8	25	8	1	0	0	4	25	1	0	8	1

Set type

Total number of set types: 37

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Cover card	Modification date	_merge
Set type
Beta set	1	535	106	1	0	2	5	1	0	0	1	1
Binder	2	6	6	2	2	0	1	2	0	0	2	1
Book promotional card	4	5	5	3	0	0	2	4	1	0	4	1
Book promotional cards	26	52	52	4	0	0	2	27	2	0	26	1
Booster pack	469	113732	11757	102	16	0	15	809	23	223	469	1
Boss Duel Deck	1	8	8	1	0	0	1	1	0	0	1	1
Bundle	9	11	11	3	0	0	1	7	1	0	9	1
Collectible tin	53	5901	1005	9	4	0	8	66	0	35	53	1
Collector's Set	11	6226	1102	7	2	3	7	14	0	6	11	1
Core Booster	1	160	80	6	0	0	2	2	0	1	1	1
Deluxe Edition	4	114	19	2	0	0	6	8	0	4	4	1
Demo Deck	4	380	64	1	0	0	7	8	0	1	4	1
Duel Disk	2	16	9	2	2	0	2	4	0	0	2	1
Duel Disk promotional cards	5	13	12	4	0	0	2	5	0	0	5	1
Duel Terminal	34	1847	706	6	2	0	2	31	0	10	34	1
Duelist League participation cards	10	60	16	3	0	0	9	9	0	0	10	1
Duelist Set	5	312	154	5	0	2	2	5	0	5	5	1
Enhancement Pack	2	20	20	1	0	0	1	1	0	0	2	1
Hobby League participation cards	40	83	43	3	0	0	5	38	0	0	40	1
Magazine promotional card	167	191	173	9	0	0	3	127	3	7	167	1
Magazine promotional cards	4	4	4	1	0	0	2	2	0	0	4	1
Main Deck	2	44	44	2	0	0	1	2	0	1	2	1
Manga promotional card	33	74	32	2	0	0	4	69	4	0	33	1
Participation card	60	485	119	5	0	0	9	71	2	0	60	1
Preconstructed Deck	6	401	223	10	3	3	2	8	0	4	6	1
Prize card	16	46	41	5	0	0	3	16	1	0	16	1
Prize cards	1	68	20	1	0	0	5	1	0	0	1	1
Promotional card	141	320	212	18	3	0	9	142	6	21	141	1
Promotional cards	25	200	62	7	2	0	10	34	1	1	25	1
Special Edition	90	1189	289	9	5	0	10	109	0	1	90	1
Starter Deck	38	6777	606	11	3	3	14	59	0	26	38	1
Structure Deck	64	9454	1206	9	2	3	10	117	1	45	64	1
Tournament prize card	1	2	2	1	0	0	1	1	0	0	1	1
Tournament promotional card	2	5	2	2	0	0	2	2	0	0	2	1
Vendor Edition	6	210	210	2	0	0	1	6	0	0	6	1
Video game promotional card	9	79	39	4	0	0	8	15	0	0	9	1
Video games promotional card	23	328	73	4	2	0	9	44	0	0	23	1

Release

Total number of release dates: 1572

	Set	Card number	Name	Rarity	Print	Quantity	Region	Series	Set type	Cover card	Modification date	_merge
Release
1999-03-01	1	0	40	1	0	0	1	1	1	0	1	1
1999-03-18	1	0	1	0	0	0	1	0	1	0	1	1
1999-04-29	1	0	1	0	0	0	1	0	1	0	1	1
1999-05-05	1	0	1	0	0	0	1	0	1	0	1	1
1999-05-25	1	0	40	1	0	0	1	1	1	0	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...
2023-01-21	1	67	61	7	0	0	1	1	1	1	1	1
2023-02-25	1	190	29	5	3	0	1	1	1	0	1	1
2023-03-01	3	2	3	2	0	0	1	0	1	0	3	1
2023-05-01	3	3	3	1	0	0	1	0	1	0	3	1
NaT	120	4071	1175	28	4	2	14	9	13	15	112	3

1573 rows × 12 columns

By year

	Set	Card number	Name	Rarity	Print	Quantity	Region	Series	Set type	Cover card	_merge
Release
1999	18	0	353	10	2	0	15	8	15	1	15
2000	11	268	318	21	2	2	9	7	10	4	9
2001	13	311	313	30	7	4	13	5	12	7	13
2002	22	1369	1197	81	10	2	21	9	20	14	19
2003	52	2672	2266	124	12	0	53	12	42	29	38
2004	93	6502	4687	193	6	0	108	27	74	45	59
2005	75	7826	4043	160	27	18	127	28	64	37	49
2006	102	5244	3048	186	22	20	125	39	93	42	67
2007	127	5747	3347	273	16	18	192	53	116	54	94
2008	125	5989	3258	269	21	12	194	51	113	50	95
2009	118	5114	2983	280	6	14	172	40	111	54	93
2010	138	6093	3322	309	8	16	204	58	124	53	103
2011	144	6922	3952	318	16	18	214	55	133	53	105
2012	141	10271	5425	349	17	20	218	57	128	53	111
2013	146	8813	4469	340	18	24	221	68	129	69	108
2014	141	12625	5705	381	38	20	225	68	126	60	107
2015	136	10432	4828	353	33	12	221	69	125	57	103
2016	137	10356	4755	331	39	10	210	62	124	59	97
2017	67	8404	3324	198	27	6	140	29	64	35	54
2018	46	5413	2129	140	26	0	103	20	41	28	41
2019	50	6264	2670	160	29	0	101	17	45	25	43
2020	38	6435	2143	150	34	0	85	18	36	27	36
2021	65	6812	2733	241	46	6	91	38	53	36	49
2022	73	8953	3673	249	66	6	96	43	61	42	56
2023	14	497	331	40	8	0	9	7	8	4	8

By month

By day

By region

		Set	Card number	Name	Rarity	Print	Quantity	Series	Set type	Cover card	Modification date	_merge
Region	Release
AE	2001-06-04	1	0	2	0	0	0	0	0	0	1	1
	2002-08-08	2	100	87	3	0	0	0	1	2	2	1
	2002-10-24	1	144	144	5	0	0	1	1	1	1	1
	2003-04-17	1	3	3	1	0	0	0	1	0	1	1
	2003-06-26	1	105	105	5	0	0	1	1	1	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...
TC	2014-01-29	1	40	40	4	0	2	0	1	1	1	1
	2014-05-01	1	20	20	4	0	0	1	1	0	1	1
	2015-03-01	2	40	26	1	0	0	0	0	0	2	1
	2015-08-29	1	100	100	6	0	0	1	1	1	1	1
	2015-12-05	1	100	100	6	0	0	1	1	1	1	1

3167 rows × 11 columns

Release	1999	2000	2001	2002	2003	2004	2005	2006	2007	2008	...	2014	2015	2016	2017	2018	2019	2020	2021	2022	2023
Region
AE	0	0	1	3	4	3	3	5	2	1	...	1	1	0	0	0	0	0	0	0	0
AU	0	0	0	0	2	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
DE	0	0	0	0	8	21	22	17	31	27	...	30	27	28	20	15	13	10	8	7	0
EN	0	0	2	2	3	16	29	48	50	45	...	43	34	35	20	15	13	10	12	11	1
EU	0	0	0	2	2	4	0	0	0	2	...	2	2	1	0	0	0	0	0	0	0
FC	0	0	0	0	2	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
FR	0	0	0	0	6	20	22	17	31	27	...	28	27	28	19	15	13	10	8	7	0
IT	0	0	0	0	5	20	21	17	31	27	...	28	27	28	20	15	13	10	8	7	0
JA	0	0	0	0	0	0	0	0	0	0	...	3	0	0	0	0	0	0	0	0	0
JP	18	11	10	11	11	20	24	27	33	41	...	43	43	52	14	16	20	14	25	26	10
KR	0	0	0	0	2	8	7	13	20	24	...	23	22	21	17	10	12	10	23	26	1
NA	0	0	0	5	16	6	0	2	2	1	...	2	3	0	2	0	0	0	0	0	0
PT	0	0	0	0	0	10	6	0	0	0	...	24	25	26	18	14	13	9	8	7	0
SC	0	0	0	0	0	0	0	0	0	0	...	0	0	0	0	0	0	4	7	10	2
SP	0	0	0	0	4	20	20	10	24	22	...	28	27	28	19	14	13	10	9	7	0
TC	0	0	0	0	0	0	0	0	0	0	...	2	4	0	0	0	0	0	0	0	0

16 rows × 25 columns

By series

		Set	Card number	Name	Rarity	Print	Quantity	Region	Set type	Cover card	Modification date	_merge
Series	Release
+1 Bonus Pack	2020-10-31	1	19	19	3	0	0	1	1	0	1	1
	2021-02-04	1	20	20	3	0	0	1	1	0	1	1
	2021-04-17	1	19	19	3	0	0	1	1	0	1	1
	2021-07-17	1	19	19	3	0	0	1	1	0	1	1
	2021-07-21	1	19	19	3	0	0	1	1	0	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...
Yu-Gi-Oh! ZEXAL manga promotional cards	2015-09-01	1	1	1	1	0	0	1	1	0	1	1
	2015-10-03	1	1	1	1	0	0	1	1	0	1	1
	2015-12-18	1	1	1	1	0	0	1	1	0	1	1
	2016-03-01	1	1	1	1	0	0	1	1	0	1	1
	2016-09-06	1	1	1	1	0	0	1	1	0	1	1

888 rows × 11 columns

Release	1999	2000	2001	2002	2003	2004	2005	2006	2007	2008	...	2014	2015	2016	2017	2018	2019	2020	2021	2022	2023
Series
+1 Bonus Pack	0	0	0	0	0	0	0	0	0	0	...	0	0	0	0	0	0	1	6	4	1
Animation Chronicle	0	0	0	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	2	2	0
Astral Pack	0	0	0	0	0	0	0	0	0	0	...	8	3	0	0	0	0	0	0	0	0
Attribute Duelist Pack	0	0	0	0	0	0	0	0	0	0	...	0	0	0	0	0	0	2	3	4	0
Battle Pack (Rush Duel)	0	0	0	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	3	4	1
Booster (series)	0	3	1	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
Booster pack	0	1	0	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
Champion Pack	0	0	0	0	0	0	0	1	3	3	...	0	0	0	0	0	0	0	0	0	0
Classic Pack	0	0	0	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	2	1
Collectors Pack	0	0	0	0	0	0	0	0	0	0	...	2	2	2	2	2	2	2	0	0	0
Core Booster	6	0	2	6	11	22	17	17	25	13	...	16	17	16	12	10	8	6	8	8	1
Deck Build Pack	0	0	0	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	2	6	0
Deck Mod Pack	0	0	0	0	0	0	0	0	0	0	...	0	0	0	0	0	0	4	9	8	2
Duelist Pack	0	0	0	0	0	0	2	9	9	10	...	1	3	5	1	0	0	0	0	0	0
Entry Pack (series)	0	0	0	0	0	0	0	0	0	0	...	0	0	0	0	0	0	1	4	4	1
Expansion Pack	0	0	0	0	0	0	0	0	0	3	...	0	0	0	0	0	0	0	0	0	0
Gold Series (series)	0	0	0	0	0	0	0	0	0	2	...	5	2	2	0	0	0	0	0	0	0
Hidden Arsenal (series)	0	0	0	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
Jump Victory Carnival	0	0	0	0	0	0	0	0	0	0	...	0	1	0	0	0	0	0	0	0	0
Legend Duelist (series)	0	0	0	0	0	0	0	0	0	0	...	0	0	0	3	4	4	1	1	1	0
Legendary Collection (series)	0	0	0	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
Master Guide promotional cards (series)	0	0	0	0	0	1	0	0	0	1	...	1	0	0	0	0	0	0	0	0	0
Mattel Action Figure promotional cards	0	0	0	0	0	0	0	3	0	0	...	0	0	0	0	0	0	0	0	0	0
McDonald's Promotional Cards	0	0	0	1	0	0	0	1	0	0	...	0	0	0	0	0	0	0	0	0	0
Monster Figure Collection promotional cards	0	0	0	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
OTS Tournament Pack	0	0	0	0	0	0	0	0	0	0	...	0	0	3	0	0	0	0	0	0	0
Perfect Rulebook promotional cards	0	0	0	0	0	0	0	0	0	0	...	1	1	1	0	0	0	0	0	0	0
Pharaoh Tour promotional cards	0	0	0	0	0	0	1	1	1	0	...	0	0	0	0	0	0	0	0	0	0
Premium Pack	0	2	2	0	0	3	1	1	1	2	...	2	2	0	0	0	0	0	0	0	0
Shonen Jump promotional cards	0	0	0	0	0	0	2	3	4	3	...	6	4	6	1	0	0	0	0	0	0
Sneak Peek Participation Cards	0	0	0	0	0	0	4	4	9	8	...	4	4	5	5	3	2	1	0	0	0
Star Pack	0	0	0	0	0	0	0	0	0	0	...	1	2	0	0	0	0	0	0	0	0
Structure Deck R	0	0	0	0	0	0	0	0	0	0	...	0	1	4	1	0	0	0	0	0	0
The Valuable Book promotional cards	1	1	0	2	1	1	1	1	1	1	...	1	1	0	1	0	0	0	0	0	0
V Jump August 1999 Special Present	1	0	0	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
V Jump Edition (series)	0	0	0	0	0	0	0	0	0	0	...	0	1	1	0	1	1	0	0	0	0
V Jump promotional cards	0	0	0	0	0	0	0	0	0	5	...	8	11	13	2	0	0	0	0	0	0
Value Box	0	0	0	0	0	0	0	0	0	0	...	1	1	0	0	0	0	0	0	0	0
Yu-Gi-Oh! 5D's manga promotional cards	0	0	0	0	0	0	0	0	0	0	...	3	3	1	0	0	0	0	0	0	0
Yu-Gi-Oh! Day promotional cards	0	0	0	0	0	0	0	0	0	0	...	2	2	2	1	0	0	0	0	0	0
Yu-Gi-Oh! GX manga promotional cards	0	0	0	0	0	0	0	1	2	3	...	0	0	0	0	0	0	0	0	0	0
Yu-Gi-Oh! R promotional cards	0	0	0	0	0	0	1	1	1	1	...	0	0	0	0	0	0	0	0	0	0
Yu-Gi-Oh! World Championship prize cards	0	0	0	0	0	1	1	1	1	1	...	1	1	1	0	0	0	0	0	0	0
Yu-Gi-Oh! ZEXAL manga promotional cards	0	0	0	0	0	0	0	0	0	0	...	6	7	2	0	0	0	0	0	0	0

44 rows × 25 columns

By set type

		Set	Card number	Name	Rarity	Print	Quantity	Region	Series	Cover card	Modification date	_merge
Set type	Release
Beta set	2017-10-04	1	535	106	1	0	2	5	0	0	1	1
Binder	2012-09-21	1	3	3	1	2	0	1	0	0	1	1
	2015-04-29	1	3	3	1	0	0	1	0	0	1	1
Book promotional card	2004-12-18	1	2	2	1	0	0	1	0	0	1	1
	2014-04-04	1	1	1	1	0	0	1	1	0	1	1
...	...	...	...	...	...	...	...	...	...	...	...	...
Video games promotional card	2011-04-28	1	7	7	1	0	0	1	0	0	1	1
	2011-05-10	1	3	3	1	0	0	1	0	0	1	1
	2013-12-05	1	3	3	1	0	0	1	0	0	1	1
	2014-06-26	1	15	3	1	0	0	5	0	0	1	1
	2016-07-16	1	1	1	1	0	0	1	0	0	1	1

1867 rows × 11 columns

Release	1999	2000	2001	2002	2003	2004	2005	2006	2007	2008	...	2014	2015	2016	2017	2018	2019	2020	2021	2022	2023
Set type
Beta set	0	0	0	0	0	0	0	0	0	0	...	0	0	0	1	0	0	0	0	0	0
Binder	0	0	0	0	0	0	0	0	0	0	...	0	1	0	0	0	0	0	0	0	0
Book promotional card	0	0	0	0	0	1	0	0	0	0	...	1	1	1	0	0	0	0	0	0	0
Book promotional cards	1	2	0	2	1	2	1	1	1	2	...	2	2	1	1	0	0	0	0	0	0
Booster pack	6	6	5	10	15	40	34	36	44	44	...	65	56	52	38	28	31	31	52	53	8
Boss Duel Deck	0	0	0	0	0	0	0	0	0	0	...	1	0	0	0	0	0	0	0	0	0
Bundle	0	0	0	0	0	0	0	0	0	0	...	1	1	0	0	0	0	0	0	0	0
Collectible tin	0	0	0	1	2	2	2	3	3	7	...	2	2	2	2	1	2	1	1	1	0
Collector's Set	0	0	0	0	0	0	0	0	0	0	...	0	2	2	0	0	3	2	1	4	0
Core Booster	0	0	0	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
Deluxe Edition	0	0	0	0	0	0	0	0	0	0	...	6	0	0	0	0	0	0	0	0	0
Demo Deck	0	0	0	0	0	0	0	0	0	0	...	0	2	2	0	3	0	0	0	0	0
Duel Disk	0	0	0	0	0	0	0	1	1	0	...	0	0	0	0	0	0	0	0	0	0
Duel Disk promotional cards	0	0	0	0	0	0	0	1	1	0	...	0	0	0	0	0	0	0	0	0	0
Duel Terminal	0	0	0	0	0	0	0	0	0	6	...	0	0	0	0	0	0	0	0	0	0
Duelist League participation cards	0	0	0	0	4	4	2	2	0	0	...	0	0	0	0	0	0	0	0	0	0
Duelist Set	0	0	0	0	0	0	0	0	0	0	...	1	0	0	0	0	0	0	0	0	0
Enhancement Pack	0	0	0	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
Hobby League participation cards	0	0	0	0	0	2	1	13	12	12	...	0	0	0	0	0	0	0	0	0	0
Magazine promotional card	1	0	0	0	0	0	3	3	4	10	...	14	15	20	3	0	0	0	0	0	0
Magazine promotional cards	0	0	0	0	1	1	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
Main Deck	0	0	0	0	0	0	0	0	0	1	...	0	0	0	0	0	0	0	0	0	0
Manga promotional card	0	0	0	1	0	0	1	4	3	4	...	9	10	3	0	0	0	0	0	0	0
Participation card	1	0	0	0	0	0	4	4	9	8	...	4	4	5	5	3	2	1	0	0	0
Preconstructed Deck	0	0	0	0	0	0	0	0	0	0	...	1	1	1	1	1	1	0	0	4	0
Prize card	0	0	2	0	0	1	1	1	1	1	...	1	1	1	0	0	0	0	0	0	0
Prize cards	0	0	0	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
Promotional card	2	0	2	1	0	1	1	9	9	5	...	5	7	17	5	3	6	2	9	11	6
Promotional cards	2	0	1	1	5	7	2	1	0	0	...	2	1	0	0	0	1	0	0	0	0
Special Edition	0	0	0	0	2	3	3	7	12	11	...	3	7	8	7	4	2	1	0	0	0
Starter Deck	1	1	0	4	13	18	2	0	3	2	...	5	7	4	0	0	0	0	2	0	0
Structure Deck	0	0	2	1	3	0	8	10	8	6	...	11	13	17	4	0	0	0	0	0	0
Tournament prize card	0	0	0	0	1	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
Tournament promotional card	0	0	0	0	1	0	1	0	0	0	...	0	0	0	0	0	0	0	0	0	0
Vendor Edition	0	0	0	0	0	1	2	2	1	0	...	0	0	0	0	0	0	0	0	0	0
Video game promotional card	1	2	0	0	0	0	0	0	5	0	...	0	0	0	0	0	0	0	0	0	0
Video games promotional card	0	0	0	1	4	8	7	4	8	4	...	1	0	1	0	0	0	0	0	0	0

37 rows × 25 columns

Debug

This section is used for debugging the extraction of data from MediaWiki query responses

Has nan name/number

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Modification date	_merge
3410	Extreme Victory	<NA>	<NA>	(Common,)	<NA>	<NA>	DE	2011-05-05	Core Booster	Booster pack	(Junk Berserker,)	2022-07-23 10:28:05	both
3511	Extreme Victory	<NA>	<NA>	(Common,)	<NA>	<NA>	JP	2011-02-11	Core Booster	Booster pack	(Junk Berserker,)	2022-07-23 10:28:05	both
3592	Extreme Victory	<NA>	<NA>	(Common,)	<NA>	<NA>	SP	2011-05-05	Core Booster	Booster pack	(Junk Berserker,)	2022-07-23 10:28:05	both
3693	Extreme Victory	<NA>	<NA>	(Common,)	<NA>	<NA>	KR	2011-06-10	Core Booster	Booster pack	(Junk Berserker,)	2022-07-23 10:28:05	both
3774	Extreme Victory	<NA>	<NA>	(Common,)	<NA>	<NA>	EN	2011-05-06	Core Booster	Booster pack	(Junk Berserker,)	2022-07-23 10:28:05	both
...	...	...	...	...	...	...	...	...	...	...	...	...	...
144883	EX Starter Box	<NA>	De-Spell	None	2	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	2022-05-01 06:51:59	both
144884	EX Starter Box	<NA>	Castle Walls	None	Reprint	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	2022-05-01 06:51:59	both
144885	EX Starter Box	<NA>	Ultimate Offering	None	Reprint	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	2022-05-01 06:51:59	both
155890	Academia Disk	<NA>	<NA>	NaN	<NA>	<NA>	<NA>	NaT	<NA>	<NA>	NaN	2022-12-28 20:46:20	right_only
155891	Structure Deck: Marik (disambiguation)	<NA>	<NA>	NaN	<NA>	<NA>	<NA>	NaT	<NA>	<NA>	NaN	2014-07-03 18:52:14	right_only

753 rows × 13 columns

Has nan rarity

array(['Dark Beginning 2', 'Dark Revelation Volume 1',
       'Yu-Gi-Oh! Duel Monsters II: Dark duel Stories Duelist Legend in Tokyo Dome attendance cards',
       'Yu-Gi-Oh! True Duel Monsters: Sealed Memories promotional cards',
       'Dark Beginning 1', 'Advanced Tournament Pack 2013 Vol.3',
       'V Jump April 2013 Tokens',
       'Yu-Gi-Oh! Duel Monsters II: Dark duel Stories Duelist Legend in Tokyo Dome invitation cards',
       'Dark Revelation Volume 2',
       'Yu-Gi-Oh! Duel Monsters II: Dark duel Stories Duelist Legend in Tokyo Dome prize cards',
       'Advanced Tournament Pack 2013 Vol.4',
       'Official Guide Starter Book promotional card',
       'Starter Box pre-order promotional card',
       'Advanced Event Pack 2013 Vol.2',
       'Duel Monsters II tournament meeting experience promotional card',
       'The Valuable Book 1 promotional cards', 'Jump Festa 2000',
       'Yu-Gi-Oh! Duel Monsters II: Dark duel Stories Duelist Legend in Tokyo Dome participation cards',
       'The Valuable Book character cards',
       'Advanced Tournament Pack 2016 Vol.1',
       'Advanced Event Pack 2014 Vol.1',
       '"Blue-Eyes White Dragon" 20th Anniversary Gold Edition',
       '"Blue-Eyes White Dragon" 20th Anniversary Silver Edition',
       '"Dark Magician" Special Card',
       '"Dark Magician Girl" Special Card',
       '25th Anniversary Ultimate Kaiba Set',
       'Asian-English Weekly Shōnen Jump lottery prize cards',
       'Booster 1', 'Booster 3',
       'Challenge from Kaiba Corporation Clear bonus',
       'Chinese Weekly Shōnen Jump lottery prize cards',
       'Classic Pack 03', 'Deck Build Pack: Tactical Masters',
       'Deck Mod Pack: Double Star of the Assault!!', 'EX Starter Box',
       'Academia Disk', 'Structure Deck: Marik (disambiguation)'],
      dtype=object)

Has quantity as print

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Modification date	_merge
144834	EX Starter Box	<NA>	De-Spell	None	2	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	2022-05-01 06:51:59	both
144883	EX Starter Box	<NA>	De-Spell	None	2	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	2022-05-01 06:51:59	both

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Modification date	_merge
144786	EX Starter Box	<NA>	Lord of D.	(New,)	<NA>	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	2022-05-01 06:51:59	both
144787	EX Starter Box	<NA>	The Flute of Summoning Dragon	(New,)	<NA>	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	2022-05-01 06:51:59	both
144788	EX Starter Box	<NA>	Dark Magician	None	<NA>	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	2022-05-01 06:51:59	both
144789	EX Starter Box	<NA>	Mystical Elf	None	<NA>	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	2022-05-01 06:51:59	both
144790	EX Starter Box	<NA>	Feral Imp	None	<NA>	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	2022-05-01 06:51:59	both
...	...	...	...	...	...	...	...	...	...	...	...	...	...
144881	EX Starter Box	<NA>	Reverse Trap	None	Reprint	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	2022-05-01 06:51:59	both
144882	EX Starter Box	<NA>	Remove Trap	None	Reprint	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	2022-05-01 06:51:59	both
144883	EX Starter Box	<NA>	De-Spell	None	2	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	2022-05-01 06:51:59	both
144884	EX Starter Box	<NA>	Castle Walls	None	Reprint	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	2022-05-01 06:51:59	both
144885	EX Starter Box	<NA>	Ultimate Offering	None	Reprint	<NA>	JP	1999-12-16	<NA>	Starter Deck	(Blue-Eyes White Dragon,)	2022-05-01 06:51:59	both

100 rows × 13 columns

Has nan release

array(['Ancient Prophecy Sneak Peek Participation Card',
       'Ancient Sanctuary',
       'Legacy of the Valiant Sneak Peek Participation Card',
       'Millennium Pack', 'National Championship 2011',
       'Shonen Jump Vol. 4, Issue 11 promotional card',
       'The New Challengers Sneak Peek Participation Card',
       'Tournament Pack 2009 Vol.3',
       "Yu-Gi-Oh! 5D's manga promotional cards", 'Curse of Anubis',
       'Shonen Jump Vol. 7, Issue 6 promotional card',
       'Hobby League 6 participation card E',
       'Yu-Gi-Oh! GX Volume 4 promotional card',
       'Crossed Souls Sneak Peek Participation Card',
       'Sneak Peek Participation Cards', 'Spell Ruler',
       'Academy Duel Disk', 'Cosmo Blazer',
       'The Lost Millennium: Special Edition',
       'Yu-Gi-Oh! Power of Chaos: Kaiba the Revenge promotional cards',
       'Astral Pack Two', 'Tournament Pack 2008 Vol.2',
       'Shonen Jump Vol. 3, Issue 6 promotional card',
       "Yu-Gi-Oh! 5D's World Championship 2011: Over the Nexus promotional cards",
       'Premium Pack 2', 'Raging Battle Sneak Peek Participation Card',
       'Yu-Gi-Oh! Worldwide Edition: Stairway to the Destined Duel promotional cards',
       'Shonen Jump Vol. 10, Issue 3 promotional card',
       'Yu-Gi-Oh! GX manga promotional cards',
       'Dimension of Chaos Sneak Peek Participation Card',
       'Yu-Gi-Oh! Championship Series Prize Cards',
       'National Championship 2012', 'Premium Pack',
       'Secrets of Eternity Sneak Peek Participation Card',
       'Shonen Jump Vol. 4, Issue 12 promotional card',
       "Yu-Gi-Oh! 5D's Volume 1 promotional card",
       'Shonen Jump Vol. 9, Issue 4 promotional card',
       'Hobby League 6 participation card F', 'Magic Ruler',
       'Gold Series', 'Invasion: Vengeance Sneak Peek Participation Card',
       "Yu-Gi-Oh! 5D's Wheelie Breakers promotional cards",
       'Astral Pack One', 'Duelist League Demo 2010',
       'Shonen Jump Vol. 6, Issue 5 promotional card',
       'Yu-Gi-Oh! The Official Magazine promotional cards',
       'Hobby League 6 participation card A',
       'Shonen Jump December 2010 subscription bonus',
       'Structure Deck: Machine Re-Volt Special Edition',
       'Shadow Specters Sneak Peek Participation Card',
       'Shonen Jump Vol. 3, Issue 9 promotional card',
       'Shonen Jump Scholastic Edition Vol. 9, Issue 1 promotional card',
       'Shonen Jump May 2006 subscription bonus',
       'Shonen Jump Vol. 10, Issue 4 promotional card',
       'Yu-Gi-Oh! R promotional cards',
       'Hobby League participation cards', 'National Championship 2013',
       'Shonen Jump Vol. 5, Issue 1 promotional card',
       'Tournament Pack 2009 Vol.4',
       'Shonen Jump Vol. 7, Issue 9 promotional card',
       'Shadow of Infinity: Special Edition',
       'Shonen Jump Vol. 9, Issue 6 promotional card',
       'Structure Deck: Marik', 'Hobby League 7 participation card A',
       'Shonen Jump May 2008 subscription bonus',
       'Shonen Jump June/July 2011 subscription bonus',
       'Shonen Jump Vol. 7, Issue 3 promotional card',
       'Hobby League 6 participation card B',
       'Shonen Jump Vol. 3, Issue 11 promotional card',
       'Shonen Jump August 2008 subscription bonus',
       'The Valuable Book promotional cards', 'The Sanctuary in the Sky',
       "Structure Deck: Dinosaur's Rage Special Set",
       'Shonen Jump Vol. 5, Issue 6 promotional card',
       'Hobby League 7 participation card B',
       'Shonen Jump Vol. 9, Issue 8 promotional card',
       'Tournament Pack 2008 Vol.1',
       'Shonen Jump Vol. 6, Issue 9 promotional card',
       'Hobby League 6 participation card C',
       'Shonen Jump Vol. 4, Issue 2 promotional card',
       'Shonen Jump Vol. 6, Issue 1 promotional card',
       'Shonen Jump May 2010 subscription bonus',
       "Structure Deck: Dinosaur's Rage Special Edition",
       'Invader of Darkness',
       'Shonen Jump Vol. 7, Issue 11 promotional card',
       'Ultimate Edition',
       'Shonen Jump Vol. 9, Issue 10 promotional card',
       'Banzai! promotional cards', 'Hobby League 7 participation card C',
       'Hobby League 6 participation card D',
       'Shonen Jump Championship Series Prize Cards',
       'Shonen Jump Vol. 9, Issue 1 promotional card', 'Duel Disk',
       'The Valuable Book character cards',
       'Hobby League 7 participation card D',
       'Shonen Jump Vol. 10, Issue 1 promotional card',
       '2013 Collectible Tins', '20th Anniversary Duel Set',
       'Booster Pack Tin Series Promos',
       'Chinese Weekly Shōnen Jump lottery prize cards',
       'Collectible Tins 2005', 'Collectible Tins 2006',
       'Collectible Tins 2007', 'Collectible Tins 2008',
       'Collectible Tins 2008 Wave 2', 'Collectible Tins 2009',
       'Collectible Tins 2010', 'Collectible Tins 2011',
       'Collectible Tins 2012',
       'Continuous Token Gifts Promotional Cards', 'Demo Pack',
       'Duelist League 18 participation cards',
       'Duelist League Series 1 participation cards',
       'Duelist League Series 2 participation cards',
       'Duelist Pack: Yugi', 'Exclusive Pack', 'Ghosts From the Past',
       'Judge promotional cards', 'Academia Disk',
       'Structure Deck: Marik (disambiguation)'], dtype=object)

Has print as rarity

array(['Booster 5', 'Booster 6',
       'Structure Deck R: Machine Dragon Re-Volt', 'Booster 7',
       'Dark Ceremony Edition', 'Booster 4', 'Booster 1',
       'EX Starter Box'], dtype=object)

Merge failed

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Modification date	_merge
155890	Academia Disk	<NA>	<NA>	NaN	<NA>	<NA>	<NA>	NaT	<NA>	<NA>	NaN	2022-12-28 20:46:20	right_only
155891	Structure Deck: Marik (disambiguation)	<NA>	<NA>	NaN	<NA>	<NA>	<NA>	NaT	<NA>	<NA>	NaN	2014-07-03 18:52:14	right_only

8

array(['2-Player Starter Deck: Yuya & Declan', '2014 Mega-Tins',
       'Absolute Powerforce', ..., 'Jump Festa 2010 - Promotion Pack',
       'Academia Disk', 'Structure Deck: Marik (disambiguation)'],
      dtype=object)

	Set	Card number	Name	Rarity	Print	Quantity	Region	Release	Series	Set type	Cover card	Modification date	_merge

Epilogue

Execution completed 16/01/2023 22:29 UTC

HTML export

Notebook saved to disk